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` = 405992 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405992 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71360,866091,379421,452671,820590,208670,62194,666781,541128,196999,518794,331983,201268,607256,541916,1033435,604433,195051,548037,35713,4505,218756,164799,320336,91828,348388,945823,119213,960066,839811,721563,343861,772902,718414,714971,338718,350159,984962,803336,630756,237379,987242,10552,930678,184100,862599,646820,738298,745452,846643,87891,231253,171989,630304,159013,688565,718154,472584,99015,914501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]