SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399223 LIMIT 1 [ RunTime:0.001525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399223 [ RunTime:0.003647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414592,754712,670681,376159,108664,246361,1010416,643946,703999,442018,631493,438579,615414,755749,480381,1021418,248548,957826,906071,710916,794424,384588,255278,445022,165479,598130,267017,103247,239111,1023087,197478,650839,519135,866995,419434,552173,385566,83874,552185,110791,829421,516881,746836,552221,583968,220373,373400,332812,145802,997376,819465,957707,13169,267260,242693,62398,530794,1009351,502063,969328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001718s ]