SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56188 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56188 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345875,809533,923504,299260,656954,668039,393330,932981,213153,1001743,85797,1033410,942072,405927,753044,691163,133720,31581,364832,64651,919387,540118,642548,57903,752669,714043,708093,591343,1012319,821882,690386,1042486,1027803,973081,588654,51244,139501,15933,110106,27916,192892,420146,593886,609893,122277,819545,724380,858481,730529,226986,970621,494098,30432,719064,177935,592560,693939,93312,1033905,51363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]