SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400300 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400300 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331486,929334,928273,41746,952593,373350,171136,536127,1019154,629074,804196,965576,1038499,517115,1014213,758253,111924,875564,155659,160128,86329,101504,771863,351404,314373,656964,77390,229614,845361,857818,168389,314566,304586,1001736,752866,322603,754246,282194,688099,827723,982480,1006894,278259,510367,656545,710435,570698,453951,413981,651300,18997,411406,464064,552431,10115,147869,502928,576755,510469,1026270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]