SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809919 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809919 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416869,16474,804346,729011,425003,780962,149849,431060,284093,973231,785290,711826,903616,910371,1014235,741193,72725,151230,555652,515201,84196,102683,50735,34847,964382,218605,781627,545449,693180,51924,14478,82952,293240,209862,505693,272856,319903,601280,354278,320224,646497,188167,248814,793651,582661,922866,485481,165078,871476,710128,436985,87591,842080,339571,683626,927781,827376,545325,943531,300752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]