SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026112 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026112 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35114,568489,797324,630763,1000685,114811,651774,623296,919581,1018721,380674,148503,795321,417920,710092,392523,658176,49536,826792,868873,399543,775554,762708,1028030,474625,112275,35335,93827,435912,564468,493990,628691,457794,610707,788261,96089,485845,919516,871094,593426,861028,859267,487339,738485,303233,926981,93005,229185,843424,425413,444735,171005,495357,887656,605202,201889,168558,855556,462144,443322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]