SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511103 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511103 [ RunTime:0.005549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024032,321678,900123,482084,410497,955611,269765,26307,343040,98030,113462,908336,257386,51027,982611,734805,632827,538272,430852,133083,801732,412620,681879,418950,838712,23805,586503,79920,569733,905499,940036,497583,9364,375603,163732,35348,582646,348715,607642,269822,112634,39746,309149,174574,52711,532566,688566,402636,442937,392115,47875,246324,686773,62758,543486,1025063,901010,996793,109079,641722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001659s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000772s ]