SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020449 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020449 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641532,447960,287778,986377,130333,791604,700702,967318,170388,439684,790781,151874,225924,30200,904327,1012157,756809,104765,469332,887818,662388,807723,982024,430536,240741,602698,422553,591962,806164,192491,337021,880199,505516,765952,1041210,182790,1031485,146794,730691,123407,159270,523378,996982,290859,938620,471337,75526,663276,377967,367154,744545,78059,593007,695154,507817,222436,130667,553495,868750,308552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020449 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020449 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]