SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405460 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405460 [ RunTime:0.002059s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463010,742240,293610,988624,492488,6312,669412,506011,187792,43844,865574,992997,291395,738559,157943,407434,717043,659100,229920,345268,426300,1008374,283472,471533,871068,872989,44592,623557,737497,345829,412617,491375,725165,396040,96735,398539,593469,575582,804548,438800,844295,886188,296542,875436,739417,615821,1006606,65323,466780,797604,654597,33520,863598,117400,168790,217876,276145,271985,195525,690231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]