SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474058 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474058 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331405,843554,678987,6522,726851,118944,725945,572019,920143,1029705,419860,1037859,537628,742879,223552,394301,731258,1015975,799289,905555,65121,875990,525969,782485,575730,811399,656176,5633,151099,929626,800933,317637,610441,718077,19949,481471,762017,101754,873756,373372,224072,843045,700153,296440,300410,930332,610015,246348,281038,32749,586282,983408,20140,276738,903760,63067,559665,798017,487685,575580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]