SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465404 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465404 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200331,456899,905253,766862,986509,534156,22405,564530,263772,550261,578832,22408,595768,980163,110704,866481,1041149,444224,514079,927680,449221,464747,689175,782905,167605,882935,284357,740385,698573,596159,552787,492522,286424,641449,349825,392161,850112,597841,63818,898861,20504,575901,924473,331442,632988,904284,124493,1024271,152506,730860,967292,379206,803909,568953,22206,704302,222788,730859,777210,208041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]