SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430012 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430012 [ RunTime:0.004804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285013,967580,507696,331151,149907,689230,56677,309998,456339,1039318,832453,217292,578558,125534,334950,793414,1021353,646335,779175,973099,577785,124577,166792,411442,549250,926456,802733,675413,646446,601112,636754,246631,621835,388648,463614,513637,218933,750847,36684,33348,884645,455231,403557,230014,32316,548283,267545,589429,170494,970568,351930,779050,387628,478975,1006007,436904,692360,74782,308378,877325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]