SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001975s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106826 LIMIT 1 [ RunTime:0.001695s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106826 [ RunTime:0.002326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14147,673249,790163,1027825,648591,414452,453219,894240,944750,187655,950966,448847,736522,339251,235933,188252,158007,531139,445992,171502,478660,771762,103114,35903,323413,849400,427596,283595,599569,478696,612684,276551,932963,33669,936318,224430,101317,210716,474125,83991,153222,223810,408563,596415,437361,1002551,487148,16572,419403,136123,174165,971328,140405,764647,309767,680607,291622,712942,684748,545653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]