SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528680 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528680 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802395,630068,756814,866857,438588,1012102,23125,642021,5686,593749,820491,975404,760973,492920,498646,133256,560849,457184,974598,788353,713041,996156,446025,4498,777997,156948,995097,723124,590442,121274,482813,750549,200530,715298,1042538,601013,291633,202860,953606,46668,703886,376183,417672,706944,804041,133929,932866,402561,497583,720559,274492,906512,61390,791126,862474,491580,290854,983050,619181,775763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]