SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002893s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269199 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269199 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43081,810010,693524,41779,1041744,1005841,607075,447264,198683,482066,403574,121563,402142,743597,205166,595414,950645,291720,278018,657795,160065,44516,702349,374857,869995,533171,25536,139896,428284,880651,411251,388089,917755,861325,1007171,638897,803990,740361,523705,889565,125458,192300,682659,691917,543624,974473,257491,940938,396680,422877,165673,475491,630146,42431,1025941,707626,892794,786307,203554,923544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269199 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269199 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]