SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803952 LIMIT 1 [ RunTime:0.001346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803952 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283029,184701,845559,994167,695367,40460,916878,87834,652456,7639,326852,79485,926080,56571,338502,678216,361099,113420,240223,986841,1019641,7400,409425,258906,499724,589943,610637,502142,211350,1010772,301068,238211,398760,493954,1019284,183527,560778,693004,711878,330676,756674,386683,59980,64862,973326,341368,1029208,404041,228888,316603,325955,652921,346098,292086,414112,736913,1002823,634129,91076,214427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002459s ]