SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414432 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414432 [ RunTime:0.004912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182506,121942,217428,186629,696411,464771,5736,1033245,1037100,70976,353556,473157,10768,1047932,572240,250519,233669,896359,1005350,698864,962075,361244,662352,32602,533814,463282,23912,807445,844532,472126,714749,438216,918155,131981,580327,131266,239333,561862,444900,338964,554339,172855,881259,54963,926159,415872,944566,216798,83360,142678,436927,258136,761046,878856,501568,796413,912900,745187,73241,540697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002407s ]