SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023308 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023308 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182663,488140,130291,184624,397697,435153,265420,136378,547227,296333,988143,846984,371581,409822,604155,187194,780833,866612,242505,960290,946388,899204,252931,205647,1030850,974095,277437,566818,226016,1017702,324133,609917,950483,936138,747194,581730,426564,20875,830528,536752,404117,574040,1019277,966707,577578,251750,385494,646976,708310,474652,27824,624010,530469,606743,930620,536003,718755,8051,900575,597931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]