SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010093 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010093 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458094,851312,26485,880629,388753,301208,376178,707782,744786,340974,268511,640653,475652,66249,438218,491916,886871,80014,387028,163595,853618,229477,664342,304535,569603,122727,718948,907226,997085,486461,244019,824065,304193,687974,61291,75469,798896,943281,778978,862165,687440,948747,708560,788398,46463,725077,679284,931136,116149,874835,344308,388918,199647,80034,1042090,1005662,278720,755401,1032606,678067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]