SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005101 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005101 [ RunTime:0.003479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715504,791520,848650,981263,899648,30034,745830,951010,183974,426946,617501,12733,651269,577001,807614,105072,710334,79563,998736,1004561,146479,707802,93824,1009845,589249,348274,123138,808324,792724,693129,215442,894839,803888,437988,321074,434414,195850,674277,467085,396826,380718,588497,455711,49156,922701,478341,997971,290011,36868,568862,641758,418990,1035234,757582,442373,620292,1039669,342535,393837,843547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001622s ]