SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282839 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282839 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80143,795013,4270,739880,25960,99300,1039224,561183,423838,700734,736355,817857,988965,390571,749293,774572,12314,587649,899063,109552,244889,910003,502274,378650,520592,569427,109117,5624,609095,319253,740720,377021,349405,664386,396062,109179,221877,50764,715152,730160,560289,177231,36856,711628,831233,469241,1028810,586975,334952,563198,958217,556227,751682,537987,500003,1023076,1023567,771075,512327,757839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]