SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513314 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513314 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677445,489488,131951,236190,1020684,336554,437176,85024,67058,857971,563542,486327,550375,1006880,679750,1037013,449954,665754,163174,488440,387060,302613,436562,676002,1011338,123483,471772,645491,543463,155665,203931,691614,534654,182180,487710,330392,247673,339920,295394,35801,908145,685096,1007683,604227,296005,242155,788015,1020237,649721,1043963,93330,230038,939568,359661,676271,694573,324937,1036170,46897,673345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000995s ]