SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404554 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404554 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686913,673062,633634,1042509,219825,296486,516958,913870,367898,945864,346980,136540,428937,452599,498464,358493,200703,767977,924769,316837,749934,379711,161347,145508,342975,625016,818362,642797,954121,929548,445968,1010439,426572,259641,286203,273397,1017193,400985,38242,665938,148190,694418,552388,601319,244842,877785,353569,720065,951996,46158,199564,312299,157081,828203,148735,896037,476000,1039598,921286,37671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000716s ]