SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473812 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473812 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670128,243801,787972,963320,651976,54090,845214,611928,997732,19737,431796,850243,465352,722150,860199,448986,111310,75369,801520,713326,360949,747193,724272,645193,149991,650863,435295,555814,177108,734941,858666,752956,704003,121772,774067,328728,702080,963960,125897,639148,948856,277915,657502,96038,152850,249646,516753,11273,426427,889414,561001,783930,399588,563189,777108,130050,243477,630800,512356,446397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]