SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433922 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433922 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865085,676790,350744,952754,813316,748144,247850,147279,36536,559584,153098,222844,327844,988006,128945,941171,773056,708529,492573,375290,91889,399191,986511,807214,652429,778795,458229,924981,315982,219968,750460,120615,818929,670557,603271,677685,848440,365494,811254,338479,575389,729424,748406,190729,254397,819799,635249,35962,781189,356281,989788,161855,447992,569044,410593,784010,340433,501475,17298,719895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]