SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566540 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566540 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011480,511810,410981,537425,250365,942083,291264,211956,114799,540177,422944,549607,16732,630661,582200,425772,357243,869627,85538,891075,972508,571861,106396,786662,278311,929534,107374,920565,483036,623512,559971,342129,895123,565660,276559,56901,169170,365254,112735,60638,156766,993376,66475,807142,608066,743720,111361,359963,962790,768563,877696,4749,53209,711403,542305,260811,561465,970624,569645,4598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]