SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331613 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331613 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005612,231077,150332,351685,722833,182306,511602,807436,77840,411571,417886,49034,604094,797250,902077,787360,998979,823279,344940,729810,292311,639328,435215,1005830,335063,473474,766987,915900,859426,820490,243830,478936,594697,975778,779408,422514,899233,263837,1001961,258866,465673,760588,813604,689819,385979,76134,939789,13322,857626,132573,613933,805343,337399,907484,980422,115445,361816,909820,348110,136340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]