SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515439 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515439 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113214,165443,248025,586672,424246,1025152,151195,144373,501260,268717,105534,803810,679465,12431,448731,92988,1037317,88576,388538,689992,739840,447827,918704,299190,134550,823862,446145,736541,668234,598345,328008,445430,111179,53366,93958,926417,942118,912130,717010,592909,181309,1020496,1032390,963449,826363,912913,169373,285657,201306,434362,594042,659905,664866,566100,82807,708557,801032,185310,148912,374953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001218s ]