SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31939 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31939 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64051,82918,201908,112120,722243,904848,239670,580903,720219,225460,609382,406316,11125,831705,492581,1008280,266050,717281,700254,66953,776214,440826,434013,696769,800465,18220,898027,203863,518186,772643,892058,508427,385075,150484,138154,390758,894886,603142,454091,971140,542222,952101,763401,785320,407305,858779,408232,169323,835523,995560,1032821,650290,1011766,375000,81509,184922,692967,325071,135708,588879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31939 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31939 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]