SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264013 LIMIT 1 [ RunTime:0.001487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264013 [ RunTime:0.003335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006786,266416,449868,910438,155578,1039452,70535,609496,962155,398343,779571,1044423,954995,1404,316751,1031011,371462,6794,156170,681158,520972,466561,297808,675608,293438,116687,597473,117122,1041506,867136,434249,310145,557682,1038734,923014,334014,760972,608428,143355,1045191,259065,922264,890992,984727,854661,118122,997647,44163,579057,431478,435577,930917,303571,495949,283358,438863,905257,534027,557584,490505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]