SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467096 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467096 [ RunTime:0.002862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531722,547474,810818,234223,409341,195428,917247,78046,778314,147834,597514,264292,342874,785186,685613,853424,807813,145368,113498,855779,784051,411196,444137,736107,269932,329478,1007304,747361,599778,705574,321528,86385,636644,218010,789346,964838,633247,232657,483259,691580,825386,617398,532465,43269,677423,761833,324691,498804,142818,1046480,777962,1002719,633181,522870,710569,80290,852229,332803,82479,158418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]