SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41962 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41962 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (409790,53203,1012269,629075,502635,1024796,584869,668604,482569,768891,43003,560629,826967,210068,936384,173042,114495,515901,601176,313003,728692,571361,595828,572332,778531,230279,903450,664557,606243,347382,716986,82243,880109,456856,247187,257654,130277,15294,332498,975257,795459,789850,465248,798049,609063,140093,601194,753591,540519,50854,781229,356046,957291,368186,198407,242166,15244,349117,585203,525231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41962 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41962 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]