SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 248423 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 248423 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198039,769783,971541,1013930,675459,855427,687299,929254,798540,423545,62742,375624,799361,456754,526076,307453,424565,679893,774207,967467,594254,1045789,830021,436644,188939,181518,261440,1012648,429478,674302,818505,885025,280236,484917,118245,67564,17079,503151,839851,737040,50380,306765,395114,607640,520171,696394,702673,12555,275603,220185,324524,719301,20800,266458,645928,878400,564858,883114,593997,628022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 248423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 248423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]