SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001677s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529787 LIMIT 1 [ RunTime:0.000992s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529787 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217144,525075,311130,836485,162951,472012,738391,885109,989717,530621,518249,20696,126970,1033122,888047,663855,297237,51772,24905,289359,988860,787285,219130,935815,245333,906957,112542,784322,419502,1022443,922357,254430,485134,886886,890934,424095,75107,316704,486793,159917,759527,598154,733617,177264,456266,136735,95996,1014710,775787,604648,714514,1011413,603657,945246,496567,251412,182535,172712,967650,1003359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001524s ]