SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610012 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610012 [ RunTime:0.001225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275669,171847,263917,417278,539217,392022,737480,8990,784639,951318,501402,287015,786519,125105,505946,606611,888416,815527,877675,970485,937569,584337,167345,170704,934020,163804,857596,361396,603759,685559,413441,578851,102240,193372,756687,324761,735249,449010,745184,605947,266625,22723,957773,986270,469331,7485,240978,573149,398993,510539,706601,518031,721953,801721,42254,75535,821096,475934,789489,372660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]