SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471541 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471541 [ RunTime:0.006346s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469166,642234,346774,660985,246516,884410,73664,235068,736923,908857,361150,242926,743428,196188,153605,719428,542111,622267,653091,112460,426537,460477,337411,742132,34678,283209,34304,792812,411975,179762,486760,637491,206838,549923,784897,407191,981262,152303,891320,68447,232552,726970,367743,53587,259248,637639,550685,1041388,973713,918986,63511,69977,756866,970379,608222,332173,1023327,475838,41411,604524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]