SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020667 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020667 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419486,421893,942870,1012303,185589,220916,348933,50325,660132,121217,240047,827855,634311,766566,106155,192775,722977,449143,825662,921050,98692,54520,273887,864575,394272,333892,550858,356362,619328,499220,414961,313501,447610,68603,228370,999341,431427,70790,415532,147873,996459,326494,514457,1004696,154444,699646,1015776,12701,274712,917334,567976,328489,713596,400316,844234,539935,891579,391889,507930,1045013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020667 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020667 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]