SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198027 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198027 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015617,479794,940544,1021097,1008329,295075,763388,847186,607835,212521,136312,519318,142171,369549,791101,744308,437611,752511,536682,1034666,161587,1031325,65732,478739,37182,230889,441671,325703,314217,416826,622917,736883,566585,1037656,804536,320636,152386,997287,612407,190871,222072,19234,1036053,1042812,184940,471554,220341,78833,742437,414251,774899,760614,841777,766137,25586,679884,680952,564986,864462,882818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]