SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511061 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511061 [ RunTime:0.004072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383021,658863,716396,100121,513730,172632,949604,461365,968269,8308,456920,615597,707653,123057,410311,713128,651130,958488,601048,129167,251348,884517,205734,78015,398236,116456,606933,29392,383980,95962,602615,639989,600453,1041961,1009679,655436,176519,817451,687379,594294,734334,530897,646674,1410,336243,266613,273093,24856,857056,599043,162810,737532,218887,626286,770572,592222,428734,821073,511271,113624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]