SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384015 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384015 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330987,478057,681081,263899,533670,404582,864150,1005917,642082,743474,79209,459095,815833,1024149,756094,857984,876567,369817,41625,41734,314151,3164,870806,363438,71278,272324,65474,676110,238170,558134,1018956,737993,581788,220313,386398,992273,374495,118029,74953,818764,1018645,499288,884942,692748,851566,291248,72350,23428,128952,539239,602915,618307,218906,1020453,955499,183578,667173,661053,20509,817192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]