SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510192 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510192 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340018,789231,915815,799089,895431,1000505,72453,505104,649594,93233,259049,871454,637418,236341,225126,635008,759673,658707,14605,785527,507902,275559,55963,317695,1025983,220039,168017,682347,191653,1046533,73387,933990,36965,163654,983156,465785,291833,113735,459254,866404,760234,958647,798224,721001,878872,964411,64794,248027,125658,70183,790468,921982,259078,1035877,2492,863420,884017,718703,633697,696343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002911s ]