SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002954s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505993 LIMIT 1 [ RunTime:0.003829s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505993 [ RunTime:0.002725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (950926,325201,281541,739160,1020419,97421,364989,867167,137600,817530,653703,164705,970584,808436,742661,691000,1026793,588636,832499,813134,885185,250404,185918,283305,44436,959604,651922,149830,893753,612497,464632,921939,361026,197702,837157,485296,94128,8540,150338,314112,207075,2404,148465,480532,231046,289083,882612,330620,985809,988467,231238,1047233,762722,404065,509798,931637,1017023,631898,732426,166311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003092s ]