SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39988 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39988 [ RunTime:0.003189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609000,442246,472268,202749,164435,765695,305829,49802,111023,49249,1033466,37236,411640,123634,244550,990860,782721,850959,725918,512729,107281,186157,410308,35206,321174,108734,940143,678618,439944,556850,9604,83034,616766,568708,579075,999932,1024545,439537,535678,597287,439552,714374,372523,223336,505433,300162,979790,531020,73873,939465,1035011,1034339,371531,313042,691295,838581,922025,458087,28739,313907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]