SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045141 LIMIT 1 [ RunTime:0.000508s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045141 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862175,92220,858909,534883,180641,850023,680313,327488,905366,811189,237856,222213,935246,479708,711716,893185,172948,709137,997538,856134,878730,881678,1002247,182195,138866,190793,860511,669755,180546,713651,287342,839952,29449,1014072,83985,308619,608437,940491,703087,616114,964344,956675,333339,559375,91328,380627,780152,714380,186420,362994,344886,310135,278584,479715,227184,869673,172514,1031198,429254,273104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]