SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501148 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501148 [ RunTime:0.003019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195175,999722,552876,416574,915655,667682,761526,325018,799116,908937,909791,898101,691253,216302,133923,617034,65755,121,757544,114284,798811,669611,504588,681557,849002,463469,432795,1012067,834161,625531,330400,894983,706408,146029,694081,987353,902173,357535,967465,107784,386226,807742,585900,726959,78561,656184,887412,568928,861432,538331,232205,321604,283959,712064,694585,750836,195609,866424,341741,545954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]