SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568238 LIMIT 1 [ RunTime:0.001337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568238 [ RunTime:0.003784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203490,346323,226076,168690,53072,485523,153567,600970,357413,835049,905619,1022292,593236,70619,747625,146635,401084,600049,93002,278249,399254,266156,217705,366046,851235,293935,545727,346503,541033,119275,187207,264788,609404,945660,49917,82703,753435,820243,909980,838846,18049,674800,113018,245002,109198,335140,975671,620840,1040918,767422,474253,868576,533623,190076,934315,274582,984465,984550,656231,174628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568238 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568238 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]