SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103974 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103974 [ RunTime:0.005102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742260,974032,188388,424705,262331,701818,1000617,589470,936375,926195,308795,844607,60974,321294,789817,521280,68208,989221,167999,135861,535868,585147,937601,470170,828488,461948,443832,11315,728518,444675,916716,641761,264527,590030,904458,231081,559393,740534,676935,984904,467357,932205,168486,835220,944479,318676,181677,551994,534481,370039,98587,129173,894370,600102,765735,50983,790169,958454,707130,369375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002932s ]