SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974801 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974801 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429136,170897,37190,1001964,548773,731899,133442,856929,120543,446653,304999,377884,203528,584649,295001,14290,426486,59189,1017355,817469,406652,282507,348477,281655,351970,101239,150345,699296,574419,19956,634371,625273,46720,541457,67291,779756,225624,668760,127187,679788,509043,111267,741040,791099,673967,455569,1021152,725155,31346,70845,277613,181797,822867,879200,411822,101223,133531,947869,715972,289932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001530s ]