SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107580 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107580 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037241,994137,691022,26380,284283,362803,156418,397435,965943,434755,179200,917369,824496,85380,464187,1039030,631583,452635,1027330,198660,191621,400037,82804,901772,115909,875875,449889,560592,484855,674449,67274,827549,881748,519460,94864,476970,247691,1046798,180643,464807,1029443,905954,970562,543326,949525,63761,272919,278832,77358,95854,371144,30041,44018,570013,51,256094,958390,961220,1047164,320269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]