SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201148 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201148 [ RunTime:0.002525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130189,172585,801637,897601,263663,3395,222002,983643,960613,695122,330324,236147,895111,281191,423526,778429,1034549,740315,77726,61981,802011,141797,625143,773190,359395,557907,52886,234142,621759,82420,374931,1025894,881092,303172,339415,338027,837428,456163,311088,238491,255461,265897,735374,892330,236574,767460,532184,563459,445741,587386,547485,747039,963713,224738,912946,894096,826415,29069,469444,1034190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]