SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341054 LIMIT 1 [ RunTime:0.010436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341054 [ RunTime:0.007037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837378,655458,887039,935455,824352,584540,588163,90640,1004239,691797,44589,197159,221510,707146,831872,79836,902380,662540,777200,932773,392787,691930,251243,314454,252179,372628,936579,5609,287991,622918,129019,327063,823430,319866,1005061,93869,982047,299130,126683,1025809,668833,42961,725323,887737,485570,868081,880386,742170,631975,723784,714333,916247,788745,573542,616817,630792,625058,988208,199990,37646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001817s ]