SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409181 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409181 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2423,320646,472220,664352,114729,396880,719977,287169,533334,379985,878613,446541,147113,342227,750830,118756,1038828,779279,70501,1043273,1012221,604269,24376,653813,207584,135928,898197,224755,146855,174485,915430,1025289,340119,478782,947527,303311,340844,144952,941735,237829,20813,886216,376345,660573,974978,648807,227348,788505,973599,310524,647639,742348,200947,902131,672536,195884,178722,742295,326785,360067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001754s ]