SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499984 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499984 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170904,207358,152036,217962,418419,512010,37129,790864,488315,456902,883749,33611,593946,484850,358354,545579,179086,750548,1013299,595388,71500,418479,50892,788333,354631,31821,436921,484467,791225,982181,729389,956441,828948,504222,755169,506255,453867,313643,59451,590398,231624,768091,442014,258735,661001,987338,89946,343449,705469,182509,364984,974835,620927,920998,494518,457866,439793,734011,395474,762117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]