SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394300 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394300 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115445,928194,139599,764770,45843,386295,508978,154518,415867,669608,618329,359739,112274,974245,492431,53800,400098,44827,970583,158421,329429,288057,710018,892514,983377,36086,1047176,37588,853893,95229,903961,824673,351710,5154,1042203,824532,761952,288522,635831,478435,544442,83350,934056,551425,395665,768524,717206,912146,1011346,79644,1023851,185244,962325,432836,1030334,554991,711948,197119,692517,96505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]