SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45100 LIMIT 1 [ RunTime:0.000917s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45100 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722935,444179,715953,540571,804638,883566,29855,816814,196672,452250,505473,763775,425143,845566,692299,1038292,479509,141560,221260,317374,898028,231116,886917,255240,352958,977184,586261,350421,706612,431431,132166,1044754,449431,138823,889117,81584,746415,497278,440165,107454,164177,635134,498459,347474,1003385,712825,981264,974363,679038,965310,294687,385574,286654,272701,599368,131144,356723,551465,864726,307186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000948s ]