SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547804 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547804 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255518,126431,1008531,483481,499420,436292,577099,474801,484579,964153,610021,1015539,771651,276085,856764,164396,50018,794771,102487,66560,399105,540873,432913,96937,160764,90515,932175,246281,218205,980141,194208,28551,924723,84126,641357,225388,787448,658913,443887,882741,300906,742502,206020,380020,1017062,522041,863957,112195,940754,509850,1027245,838392,450721,421572,321845,69132,342132,729325,223856,39552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]