SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332180 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332180 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295250,195672,184613,715574,25271,393959,214635,483725,59832,615540,920392,228739,104182,40708,468061,145734,172913,949349,5356,373619,911888,530253,105683,851050,535232,981755,922651,982925,378864,441429,74224,99238,746540,749034,922943,226282,501726,854944,656763,492811,308395,733182,976419,755757,821368,839032,631802,942760,404171,697900,844281,192278,786223,1036611,48148,426340,645766,38697,28628,774435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]