SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 856401 LIMIT 1 [ RunTime:0.001488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 856401 [ RunTime:0.004441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750070,915038,272631,54019,107771,840541,1012240,889851,444376,114606,441040,857509,336234,442240,541423,995680,301031,135996,450512,175074,956467,987407,556986,453591,52863,949600,165516,847261,472628,80969,1016715,8560,336078,991536,380636,651630,735603,293203,522544,969480,1015759,482205,324814,302608,398993,50851,581675,142528,405812,143824,779920,400443,621312,524433,297785,594594,107204,165426,459779,543092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.017787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 856401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 856401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]