SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012135 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012135 [ RunTime:0.004046s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879042,428035,849029,100526,839327,980670,1018318,77958,350041,35575,772400,229228,1026805,501455,103223,528057,556615,911418,851194,67264,521967,820766,523169,799296,733777,219624,693729,382989,627453,592356,889201,861187,536078,844047,653522,236604,403703,1024173,694983,54784,674584,95957,716578,491407,106065,613456,446044,109545,785925,1007321,1015790,551552,635836,566908,72601,82248,607397,892706,812787,283098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001056s ]