SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002812s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538891 LIMIT 1 [ RunTime:0.000754s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538891 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823684,928950,923040,245087,587908,763179,825190,586574,907314,347253,114007,495276,42378,628163,508754,84212,57876,61186,419954,1036210,114510,158011,1016018,427404,1012088,307148,163091,636534,240988,1040449,772079,868740,651948,97548,376268,452918,103396,658225,528562,539587,861411,569607,62984,992023,18935,29748,477859,213019,516629,640659,445563,521444,193968,577630,28934,916594,168634,701947,370358,338008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]