SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504850 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504850 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305943,543587,116775,848816,734428,397090,1021521,831760,36790,999172,308530,145831,136047,493731,109932,657308,636332,351189,886669,874363,609947,81596,461556,465821,546162,139927,928384,354356,751508,235976,986566,336032,906029,908288,468269,325116,10172,421532,160529,534155,593280,953887,665753,919825,842067,395105,218365,510307,715652,804453,66280,142208,936173,117268,4046,397237,518406,589821,7283,167087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]