SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020281 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020281 [ RunTime:0.002922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878667,267748,822554,783627,433296,47748,269541,868401,403993,997721,857774,312440,162818,1042141,148196,832717,338641,185909,720727,349685,3550,41626,171094,351091,361480,645723,850161,456634,287864,884608,594331,351351,324408,591165,738400,877156,68879,144139,585705,1012039,469243,97396,508833,177901,96172,1005115,1044809,979815,809663,301340,950154,626581,193529,901052,274849,926614,22075,159051,20197,819528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003699s ]