SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533458 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533458 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778200,102647,101112,584585,1048807,564560,61239,887993,976881,852855,643674,23069,511577,357543,848804,714260,943997,710229,173336,718350,413730,248740,234642,744834,555568,635076,655964,534467,301180,136677,1037924,454642,547524,813785,824134,747685,416752,896992,240017,640512,277640,795875,332922,619576,879844,270182,532049,107850,178592,428947,545955,515534,833921,760493,133355,171229,200879,385152,404478,701122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]