SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447810 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447810 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460389,753880,995921,462789,306963,71276,496012,1038316,282953,707383,782387,745042,23034,927842,302658,468095,521284,853650,295230,224735,98814,936691,513854,453107,930612,927724,166954,506265,30733,242724,100667,719344,603336,255139,574042,466808,163542,527534,1027804,991711,941277,1043452,247646,1022837,1015011,665250,453102,910126,86326,959080,1011839,231270,182318,920625,442269,268522,101192,759967,759166,1031979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]