SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503416 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503416 [ RunTime:0.001462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881576,395513,813074,131694,583857,264731,398945,749914,302618,322298,997587,825750,907338,551495,165380,586566,654007,797062,808271,163800,625056,495624,125531,1012043,197530,661607,741502,357264,133695,733418,373289,882611,894223,312139,249041,685722,824887,479899,835376,709457,257808,334339,167624,624673,224328,338734,764389,107771,548651,358732,950071,516,417337,421365,539592,584082,821648,292603,742843,37776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]